<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
</head>

<body>
<h1>Guitar Wars - High Scores</h1>
<div>
	<?php
		$dbc=mysqli_connect('localhost','root','root','elvis_store')or die('Error connecting to MySQL server.');
		mysqli_query($dbc,'set names "utf8"'); 
		$query = "select * from guitarwars";
		$result=mysqli_query($dbc,$query);
		while ($row=mysqli_fetch_array($result)){
			echo "<p style='color:#FF6633; font-size:18px; font-weight:600;'>".$row['score']."</p>";
			echo "<p style='font-size:12px'>Name：". $row['name']."</p>";
			echo "<p>Data:". $row['date']."</p>";
		}
		mysqli_close($dbc);
	?>
</div>
</body>
</html>
